package cn.yuanqiao.archive.Identify.mapper;/**
 * @author 赵常飞
 * @date 2023/9/19 11:24
 */

import cn.yuanqiao.archive.Identify.domain.TenantYqxhjdFolderDa;
import cn.yuanqiao.archive.Identify.domain.TenantYqxhjdJob;
import cn.yuanqiao.archive.Identify.domain.TenantYqxhjdJobDa;
import cn.yuanqiao.archive.Identify.domain.TenantYqxhjdTask;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 *
 *@AUTHOR:赵常飞
 *@date 2023/9/19 11:24
 */
public interface DestructionMapper {
    int createdestructionJobTable(@Param("tableName") String tableName);

    int createdestructionJobDaTable(@Param("tableName") String tableName);

    int createdestructionjdTask(@Param("tableName")String tableName);

    int createdestructionjdFolderDaTable(@Param("tableName") String tableName);

    public List<Map<String, Object>> getlistfromcz(@Param("fields") String fields, @Param("tablename") String tablename, @Param("bgqxgqsql") String bgqxgqsql, @Param("lczsql") String lczsql, @Param("tiaojian") String tiaojian, @Param("orderstr") String orderstr);

    int addtask(TenantYqxhjdTask task);

    int addjob(TenantYqxhjdJob xhjdJob);

    Map<String, Object> getjobinfo(TenantYqxhjdJob yqxhjdJob);

    int updatejobinfo(TenantYqxhjdJob yqxhjdJob);

    int insertda(TenantYqxhjdJobDa yqxhjdJobDa);

    int insertfolderda(TenantYqxhjdFolderDa yqxhjdFolderDa);

    int updatetask(TenantYqxhjdTask task);

    List<TenantYqxhjdJobDa> getyqKfjdJobDabyrenwuid(@Param("renwuid")Long renwuid,@Param("tableName") String tableName);

    Integer getvfxhnum(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("daid")Long daid);

    Integer getxhnxhnum(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("jiandingfield") String jiandingfield,@Param("value") String value,@Param("daid")Long daid);

    int updatedatable1(TenantYqxhjdJobDa jobDa);

    int updatefolderda1(TenantYqxhjdFolderDa folderDa);

    int shendingtijiao(TenantYqxhjdJobDa yqxhjdJobDa);

    int shendingtijiaofolderda(TenantYqxhjdFolderDa folderDa);

    int updateresult(@Param("maintableName")String maintableName, @Param("mainfield")String mainfield,@Param("subTableName") String subTableName, @Param("subfield")String subfield,@Param("idsql") String idsql,@Param("jobdatable")String jobdatable,@Param("renwuid")String renwuid,@Param("nowdate")String nowdate);

    List<Map<String, Object>> gettongjibyjobname(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable);

    List<Map<String, Object>> gettongjibycate(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable);

    List<Map<String, Object>> gettongjibyqzh(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable);

    List<Map<String, Object>> gettongjibyuserchushen(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable,@Param("userid")String userid);

    List<Map<String, Object>> gettongjibyuserfushen(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable,@Param("userid")String userid);

    List<Map<String, Object>> exportjobdadata(@Param("renwuid")Long renwuid,@Param("tableName")String tableName, @Param("searchtable")String searchtable, @Param("fields")String fields,@Param("orderstr") String orderstr,@Param("ids") List ids,@Param("dicttable")String dicttable);

    List<Map<String, Object>> getcomplatejob(@Param("tableName")String tableName);

    List<Map<String, Object>> getqingce(@Param("subTableName")String tableName,@Param("jobDatable")String jobDatable,@Param("catetable")String catetable,@Param("folderDatable")String folderDatable,@Param("filetablename")String filetablename,@Param("id")Long id);
}
